1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class uctBanHangMod
15 {
16 protected string MaSanPham { get; set; }
17 protected int KhachHangId { get; set; }
18 protected string TrangThaiStr { get; set; }
19 protected int TrangThaiInt { get; set; }
20
21 protected string TrangThaiGiaoDich { get; set; }
22 protected DateTime NgayMuaHang { get; set; }
23 protected int PageSize {get; set;}
24 protected int PageIndex {get; set;}
25
26 public uctBanHangMod()
27 { }
28
29 public uctBanHangMod(int _TrangThaiInt, DateTime _NgayMuaHang, string _TrangThaiGiaoDich)
30 {
31 TrangThaiInt = _TrangThaiInt;
32 NgayMuaHang = _NgayMuaHang;
33 TrangThaiGiaoDich = _TrangThaiGiaoDich;
34 }
35
36 //bang kho trangthai = string
37 public uctBanHangMod(string _MaSanPham, string _TrangThaiStr)
38 {
39 MaSanPham = _MaSanPham;
40 TrangThaiStr = _TrangThaiStr;
41 }
42
43 //bang ban hang trangthai = int
44 public uctBanHangMod(string _MaSanPham, int _TrangThaiInt, int _KhachHangId)
45 {
46 MaSanPham = _MaSanPham;
47 TrangThaiInt = _TrangThaiInt;
48 KhachHangId = _KhachHangId;
49 }
50
51 public uctBanHangMod(int _TrangThaiInt, int _KhachHangId, string _TrangThaiGiaoDich, DateTime _NgayMuaHang, int _pageSize, int _pageIndex)
52 {
53 TrangThaiInt = _TrangThaiInt;
54 KhachHangId=_KhachHangId;
55 TrangThaiGiaoDich=_TrangThaiGiaoDich;
56 NgayMuaHang= _NgayMuaHang;
57 PageSize= _pageSize;
58 PageIndex = _pageIndex;
59
60 }
61
62 public DataSet uctBanHang_BanHang_gets()
63 {
64 DataSet ds = new DataSet();
65 string[] paras = new string[3] { "@MaSanPham", "@TrangThaiInt", "@KhachHangId" };
66 object[] values = new object[3] { MaSanPham, TrangThaiInt, KhachHangId };
67 ds = Models.connection.FillDataSet("uctBanHang_BanHang_Gets", CommandType.StoredProcedure, paras, values);
68 return ds;
69 }
70
71 public DataSet uctBanHang_Kho_get()
72 {
73 DataSet ds = new DataSet();
74 string[] paras = new string[2] { "@MaSanPham", "@TrangThaiStr" };
75 object[] values = new object[2] { MaSanPham, TrangThaiStr };
76 ds = Models.connection.FillDataSet("uctBanHang_Kho_Get", CommandType.StoredProcedure, paras, values);
77 return ds;
78 }
79
80 //khach hang truoc
81 public DataSet uctBanHang_Gets_KhachHangTruoc()
82 {
83
84 DataSet ds = new DataSet();
85 string[] paras = new string[6] { "@TrangThaiInt", "@KhachHangId", "@TrangThaiGiaoDich", "@NgayMuaHang", "@PageSize", "@PageIndex" };
86 object[] values = new object[6] { TrangThaiInt, KhachHangId, TrangThaiGiaoDich, NgayMuaHang, PageSize, PageIndex };
87 ds = Models.connection.FillDataSet("uctBanHang_Gets_KhachHangTruoc", CommandType.StoredProcedure, paras, values);
88 return ds;
89 }
90
91 //them moi khach hang
92 public int uctBanHang_KhachHang_Insert()
93 {
94 int i = 0;
95 string[] paras = new string[3] { "@TrangThaiInt", "@NgayMuaHang", "@TrangThaiGiaoDich"};
96 object[] values = new object[3] { TrangThaiInt, NgayMuaHang, TrangThaiGiaoDich};
97 i = Int32.Parse(Models.connection.ExcuteScalar("uctBanHang_KhachHang_Insert", CommandType.StoredProcedure, paras, values));
98 return i;
99 }
100 }
101 }